<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1 plus MathML 2.0//EN" "http://www.w3.org/Math/DTD/mathml2/xhtml-math11-f.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US">
<!--This file was converted to xhtml by LibreOffice - see https://cgit.freedesktop.org/libreoffice/core/tree/filter/source/xslt for the code.-->

<head profile="http://dublincore.org/documents/dcmi-terms/">
<meta http-equiv="Content-Type" content="application/xhtml+xml; charset=utf-8"/>
<title xml:lang="en-US">BiblioteQ Documentation</title>
<meta name="DCTERMS.title" content="" xml:lang="en-US"/>

<meta name="DCTERMS.language" content="en-US" scheme="DCTERMS.RFC4646"/>
<meta name="DCTERMS.source" content="http://xml.openoffice.org/odf2xhtml"/>

<meta name="DCTERMS.issued" content="2017-10-29T19:38:42.577542581" scheme="DCTERMS.W3CDTF"/>

<meta name="DCTERMS.modified" content="2025-05-07T18:32:22.328269936" scheme="DCTERMS.W3CDTF"/>
<meta name="DCTERMS.provenance" content="Printed by &quot;PDF files&quot;[dc:publisher] on &quot;2025-05-07T18:32:27.335223661&quot;[dc:date] in &quot;en-US&quot;[dc:language]" xml:lang="en-US"/>

<meta name="xsl:vendor" content="libxslt"/>
<link rel="schema.DC" href="http://purl.org/dc/elements/1.1/" hreflang="en"/>
<link rel="schema.DCTERMS" href="http://purl.org/dc/terms/" hreflang="en"/>
<link rel="schema.DCTYPE" href="http://purl.org/dc/dcmitype/" hreflang="en"/>
<link rel="schema.DCAM" href="http://purl.org/dc/dcam/" hreflang="en"/>

<style>
    table { border-collapse:collapse; border-spacing:0; empty-cells:show }
    td, th { vertical-align:top; font-size:12pt;}
    h1, h2, h3, h4, h5, h6 { clear:both;}
    ol, ul { margin:0; padding:0;}
    li { list-style: none; margin:0; padding:0;}
    span.footnodeNumber { padding-right:1em; }
    span.annotation_style_by_filter { font-size:95%; font-family:Arial; background-color:#fff000;  margin:0; border:0; padding:0;  }
    span.heading_numbering { margin-right: 0.8rem; }* { margin:0;}
    .graphic-fr1{ background-color:transparent; font-size:12pt; font-family:'Liberation Serif'; vertical-align:top; writing-mode:horizontal-tb; direction:ltr; }
    .graphic-fr2{ background-color:transparent; font-size:12pt; font-family:'Liberation Serif'; text-align:center; vertical-align:top; writing-mode:horizontal-tb; direction:ltr; }
    .graphic-fr3{ background-color:transparent; font-size:12pt; font-family:'Liberation Serif'; text-align:center; vertical-align:top; writing-mode:horizontal-tb; direction:ltr; }
    .graphic-fr4{ background-color:transparent; font-size:12pt; font-family:'Liberation Serif'; text-align:center; vertical-align:top; writing-mode:horizontal-tb; direction:ltr; }
    .paragraph-Contents_20_1{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;margin-left:0in; margin-right:0in; text-indent:0in; }
    .paragraph-Contents_20_2{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;margin-left:0.1965in; margin-right:0in; text-indent:0in; }
    .paragraph-Contents_20_3{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;margin-left:0.3929in; margin-right:0in; text-indent:0in; }
    .paragraph-Contents_20_4{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;margin-left:0.5898in; margin-right:0in; text-indent:0in; }
    .paragraph-Contents_20_Heading{ font-size:16pt; margin-bottom:0.0835in; margin-top:0.1665in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;margin-left:0in; margin-right:0in; text-indent:0in; font-weight:bold; }
    .paragraph-Footer{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-Horizontal_20_Line{ font-size:6pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;margin-top:0in; margin-bottom:0.1965in; padding:0in; border-left-style:none; border-right-style:none; border-top-style:none; border-bottom-width:0.0399cm; border-bottom-style:double; border-bottom-color:#808080; }
    .paragraph-Index_20_1{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;margin-left:0in; margin-right:0in; text-indent:0in; }
    .paragraph-Index_20_Heading{ font-size:16pt; margin-bottom:0.0835in; margin-top:0.1665in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;margin-left:0in; margin-right:0in; text-indent:0in; font-weight:bold; }
    .paragraph-P1{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P10{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P100{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-style:normal; }
    .paragraph-P101{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-style:normal; }
    .paragraph-P102{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P103{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P104{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P105{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P106{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P107{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P108{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P109{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P11{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P110{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P111{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P112{ font-size:28pt; font-weight:bold; margin-bottom:0.0835in; margin-top:0.1665in; text-align:center ! important; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P113{ font-size:18pt; margin-bottom:0.0835in; margin-top:0.0417in; text-align:center ! important; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P114{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P115{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P116{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P117{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P118{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P119{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P12{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P120{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P121{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P122{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P123{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P124{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P125{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P126{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P127{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P128{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P129{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P13{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P130{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P131{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P132{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P133{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P134{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P135{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P136{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P137{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P138{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P139{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P14{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P140{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P141{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P142{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P143{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P144{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P145{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P146{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P147{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P148{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P149{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P15{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P150{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P151{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P152{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P153{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P154{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P155{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P156{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P157{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P158{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P159{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P16{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P160{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P161{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P162{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P163{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P164{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P165{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P166{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P167{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P168{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P169{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P17{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P170{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P171{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P172{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P173{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P174{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P175{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P176{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P177{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P178{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P179{ font-size:12pt; margin-left:0in; margin-right:0in; text-indent:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P18{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P180{ font-size:16pt; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P181{ font-size:16pt; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P182{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P183{ font-size:12pt; margin-left:0in; margin-right:0in; text-indent:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P184{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P185{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P186{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P187{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P188{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P189{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P19{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;text-align:center ! important; }
    .paragraph-P190{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P191{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P192{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P193{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P194{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P195{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P196{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P197{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P198{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P199{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P20{ font-size:14pt; margin-bottom:0.0835in; margin-top:0.1665in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;text-align:center ! important; }
    .paragraph-P200{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P201{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P202{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P203{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P204{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P205{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P206{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P207{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P208{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P209{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P21{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P210{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P211{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P212{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P213{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P214{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P215{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P216{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P217{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P218{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P219{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P22{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P220{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P221{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P222{ font-size:130%; font-weight:bold; margin-bottom:0.0835in; margin-left:0in; margin-right:0in; margin-top:0.1665in; text-indent:0in; font-family:'Liberation Sans'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P223{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P224{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P225{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P226{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P227{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P228{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P229{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P23{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P230{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P231{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P232{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P233{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P234{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P235{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P236{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P237{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;font-weight:bold; }
    .paragraph-P238{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P239{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P24{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P240{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P241{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P242{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P243{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P244{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P245{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P246{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P247{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P248{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P25{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P26{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P27{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P28{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P29{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P3{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P30{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P31{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P32{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P33{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P34{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P35{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P36{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P37{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P38{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P39{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P4{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P40{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P41{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P42{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P43{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P44{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P45{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P46{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P47{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P48{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P49{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P5{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P50{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P51{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P52{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P53{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P54{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P55{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P56{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P57{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P58{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P59{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P6{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P60{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P61{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P62{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P63{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P64{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P65{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P66{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P67{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P68{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P69{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P7{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P70{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P71{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P72{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P73{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P74{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P75{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P76{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P77{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P78{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P79{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P8{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P80{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P81{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P82{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P83{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P84{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P85{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P86{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P87{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P88{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P89{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P9{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P90{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P91{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P92{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P93{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P94{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P95{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P96{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P97{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P98{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-P99{ font-size:12pt; line-height:120%; margin-bottom:0.0972in; margin-top:0in; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;}
    .paragraph-Text_20_body{ font-size:12pt; font-family:'Liberation Serif'; writing-mode:horizontal-tb; direction:ltr;margin-top:0in; margin-bottom:0.0972in; line-height:120%; }
    .text-Bullet_20_Symbols{ font-family:OpenSymbol; }
    .text-Emphasis{ font-style:italic; }
    .text-Internet_20_link{ color:#000080; text-decoration:underline; }
    .text-Source_20_Text{ font-family:'Liberation Mono'; }
    .text-T18{ font-style:italic; }
    .text-T184{ font-family:'Liberation Serif'; }
    .text-T185{ font-family:'Liberation Serif'; }
    .text-T186{ font-family:'Liberation Serif'; }
    .text-T187{ font-family:'Liberation Serif'; }
    .text-T188{ font-family:'Liberation Serif'; }
    .text-T19{ font-style:italic; }
    .text-T20{ font-style:italic; }
    .text-T21{ font-style:normal; }
    .text-T212{ font-weight:bold; }
    .text-T213{ font-weight:bold; }
    .text-T214{ font-weight:bold; }
    .text-T215{ font-weight:bold; }
    .text-T216{ font-weight:bold; }
    .text-T217{ font-weight:bold; }
    .text-T218{ font-weight:bold; }
    .text-T22{ font-style:normal; }
    .text-T23{ font-style:normal; }
    /* ODF styles with no properties representable as CSS:
    .dp1 .Sect1 .Sect2 .Endnote_20_Symbol .Footnote_20_Symbol .Index_20_Link .Numbering_20_Symbols .T1 .T10 .T100 .T101 .T102 .T103 .T104 .T105 .T106 .T107 .T108 .T109 .T11 .T110 .T111 .T112 .T113 .T114 .T115 .T116 .T117 .T118 .T119 .T12 .T120 .T121 .T122 .T123 .T124 .T125 .T126 .T127 .T128 .T129 .T13 .T130 .T131 .T132 .T133 .T134 .T135 .T136 .T137 .T138 .T139 .T14 .T140 .T141 .T142 .T143 .T144 .T145 .T146 .T147 .T148 .T149 .T15 .T150 .T151 .T152 .T153 .T154 .T155 .T156 .T157 .T158 .T159 .T16 .T160 .T161 .T162 .T163 .T164 .T165 .T166 .T167 .T168 .T169 .T17 .T170 .T171 .T172 .T173 .T174 .T175 .T176 .T177 .T178 .T179 .T180 .T181 .T182 .T183 .T189 .T190 .T191 .T192 .T193 .T194 .T195 .T196 .T197 .T198 .T199 .T200 .T201 .T202 .T203 .T204 .T205 .T206 .T207 .T208 .T209 .T210 .T211 .T219 .T24 .T25 .T26 .T27 .T28 .T29 .T3 .T30 .T31 .T32 .T33 .T34 .T35 .T36 .T37 .T38 .T39 .T4 .T40 .T41 .T42 .T43 .T44 .T45 .T46 .T47 .T48 .T49 .T5 .T50 .T51 .T52 .T53 .T54 .T55 .T56 .T57 .T58 .T59 .T6 .T60 .T61 .T62 .T63 .T64 .T65 .T66 .T67 .T68 .T69 .T7 .T70 .T71 .T72 .T73 .T74 .T75 .T76 .T77 .T78 .T79 .T8 .T80 .T81 .T82 .T83 .T84 .T85 .T86 .T87 .T88 .T89 .T9 .T90 .T91 .T92 .T93 .T94 .T95 .T96 .T97 .T98 .T99  { } */
</style>
</head>

<body dir="ltr" style="max-width:8.5in;margin-top:0.7874in; margin-bottom:0.7874in; margin-left:0.7874in; margin-right:0.7874in; ">
<p class="paragraph-Horizontal_20_Line"> </p>
<p class="paragraph-P112">BiblioteQ</p>

<p class="paragraph-P113">A <span class="text-T192">Software </span><span class="text-T181">Suite</span></p>

<p class="paragraph-P20"><span class="text-T179">202</span><span class="text-T193">5</span><span class="text-T179">.</span><span class="text-T193">0</span><span class="text-T194">5</span><span class="text-T193">.0</span><span class="text-T219">7</span></p>
<p class="paragraph-P19"> </p><table border="0" cellspacing="0" cellpadding="0" class="table-Sect1"><colgroup/>
<p class="paragraph-P180">Table of Contents</p>
<tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc105_989239493">Introduction</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1328_551497558">Accessing an Existing SQLite Database</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2065_695315335">Adding An Item</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1313_744196591">Administrator Browser</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2910_2972840720">BiblioteQ.INI</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc3090_2972840720">BiblioteQ.conf</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1452_257133660">Change Password</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc363_19725849">Connecting to a PostgreSQL Database</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc443_940074755">Creating a PostgreSQL Database</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc322_551497558">Creating an SQLite Database</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1520_1056771071">Custom Query</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2642_1297078973">Database Content</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1455_73510555">Database Enumerations Browser</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc413_940074755">Disconnecting from a Database</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1754_560018603">Error Log</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc460_1725578287">Exporting a Table View to a CSV File</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2813_3142272184">File Attachments</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2118_278443408">Hyperlinks</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2602_4162988163">Importing</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1814_537498170">Limitations</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1050_1842839021">Main Window Tool Buttons</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc4991_1789080889">Members Browser</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1179_960857923">Member’s Reservation History</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc3441_676261051">Open Library</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1583_330706588">Operating Systems</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1774_205534156">PDF</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc505_1495128750">PostgreSQL Accounts</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2714_3991642868">PostgreSQL Benefits</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2401_2018030115">PostgreSQL unaccent()</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc687_979507714">Preparing biblioteq.conf</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1852_1012006322">Requesting an Item</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2048_824278855">Reserving an Item</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2050_824278855">Returning an Item</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2479_3383179068">SQL Injections</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2216_278443408">SRU &amp; Z39.50</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc2479_33831790681">Special Data</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1119_9608579231">Terminal Options</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1119_960857923">Translations</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1570_1648101563">Upgrading a PostgreSQL Database Schema</a></p></td></tr><tr><td><p class="paragraph-P179"><a href="#__RefHeading___Toc1523_1648101563">Upgrading an SQLite Database Schema</a></p></td></tr></table><p class="paragraph-P9"> </p><h1 class="paragraph-P185"><a id="a__Introduction"><span/></a><a id="__RefHeading___Toc105_989239493"/>Introduction</h1>

<p class="paragraph-P10"><span class="text-T5">BiblioteQ is a</span> <span class="text-T5">complex </span><span class="text-T195">and </span><span class="text-T5">highly-configurable library </span><span class="text-T182">suite</span><span class="text-T5">. The software supports large, medium, and small institutions.</span></p>

<p class="paragraph-P8">BiblioteQ <span class="text-T195">is </span>functional on any operating system where Qt <span class="text-T146">LTS</span>, SQLite, and YAZ are supported. BiblioteQ also supports the PostgreSQL database engine. <span class="text-T130">Qt 4.8.x is considered obsolete </span><span class="text-T142">and is not supported</span><span class="text-T130">. </span><span class="text-T153">The YAZ library is optional.</span></p>

<p class="paragraph-P34">The source <span class="text-T131">of BiblioteQ </span>is available at <a href="https://github.com/textbrowser/biblioteq" class="text-Internet_20_link"><span class="text-T4">https://github.com/textbrowser/biblioteq</span></a><span class="text-T4">.</span></p>

<p class="paragraph-P35">The purpose of this document is to detail the functionality of BiblioteQ. Installation instructions are not described in this document. Please refer to the Administrator Guide document for installation information.</p>
<p class="paragraph-P7"> </p><h1 class="paragraph-P186"><a id="a__Accessing_an_Existing_SQLite_Database"><span/></a><a id="__RefHeading___Toc1328_551497558"/>Accessing an Existing SQLite Database</h1>

<p class="paragraph-Text_20_body"><a id="__RefHeading___Toc1354_551497558"/>An existing SQLite database file may be opened via two methods. The first method involves the Recent SQLite Files option of the File menu.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-Text_20_body">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.4598in;width:3.0835in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr2" id="Image3"><img style="height:6.2479cm;width:7.8321cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>

<p class="paragraph-P83">The <span class="text-T7">Recent SQLite Files </span>sub-menu contains a list of <span class="text-T14">BiblioteQ’s</span> recently-accessed SQLite files. <span class="text-T7">If an SQLite file is selected, the specified SQLite database is opened. Please note that BiblioteQ will first close an existing database, if one is open, before opening the specified database. A </span><span class="text-T7">Clear</span><span class="text-T7"> option is also included in the sub-menu. If Clear is activated, the list of the recently-accessed SQLite files is emptied. BiblioteQ will remove duplicate </span><span class="text-T20">sqlite_db_</span><span class="text-T22"> entries from the INI file shortly after the application is launched. Also removed will be entries </span><span class="text-T23">whose corresponding</span><span class="text-T22"> files lack read and write p</span><span class="text-T23">ermissions.</span></p>

<p class="paragraph-Text_20_body"><a id="__RefHeading___Toc1358_551497558"/>The second <span class="text-T9">method of accessing an SQLite database</span> <span class="text-T80">is through</span> the Branch Selection dialog. The dialog may be <span class="text-T8">accessed</span> via the Connect option of the File menu.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-Text_20_body">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.2811in;width:6.198in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr4" id="Image4"><img style="height:5.794cm;width:15.7429cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>

<p class="paragraph-Text_20_body"><a id="__RefHeading___Toc1360_551497558"/><span class="text-T15">After opening the Branch Selection dialog, s</span>elect local_db as the Branch Name. <span class="text-T81">This will prepare the dialog for accessing SQLite databases</span>. Afterwards, click on the Select SQLite Database button to launch a file-selection dialog.</p>
<h1 class="paragraph-P187"><a id="a__Adding_An_Item"><span/></a><a id="__RefHeading___Toc2065_695315335"/>Adding <span class="text-T154">A</span>n Item</h1>

<p class="paragraph-P91">For PostgreSQL databases, items may be added by administrator and librarian accounts. For SQLite databases, <span class="text-T108">file </span>owners may add items.</p>

<p class="paragraph-P91">BiblioteQ supports books, compact discs, digital video discs, grey literature, journals, magazines, photograph collections, and video games.</p>

<p class="paragraph-P91">To add an item, click on the Add Item tool button and select the desired category. <span class="text-T99">A</span><span class="text-T196">n item-c</span><span class="text-T99">reate</span><span class="text-T99"> window will be displayed. Required fields are highlighted.</span></p>

<p class="paragraph-P106">Multiple items may be added simultaneously.</p>
<p class="paragraph-P106"> </p><h1 class="paragraph-P188"><a id="a__Administrator_Browser"><span/></a><a id="__RefHeading___Toc1313_744196591"/>Administrator Browser</h1>

<p class="paragraph-P73">The Administrator Browser is available <span class="text-T63">if</span> <span class="text-T56">an </span><span class="text-T56">administrator</span> <span class="text-T82">role </span>is connected to a PostgreSQL database. <span class="text-T64">The browser may be accessed via the </span><span class="text-T64">Configure</span><span class="text-T64"> Administrator Privileges</span><span class="text-T64"> </span><span class="text-T197">(PostgreSQL) </span><span class="text-T64">tool button.</span></p>

<p class="paragraph-P77">Four roles are available. Changes <span class="text-T170">should</span> be committed via the Save Changes button.</p>

<p class="paragraph-P74">The process of committing changes to the PostgreSQL database is as follows:</p>
<ol><li><p class="P223" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">1.</span>The <span class="text-T109">table’s </span>current state is inspected. <span class="text-T132">The operator is notified of a</span>dministrators without privileges <span class="text-T58">as well as</span> duplicate administrators <span class="text-T65">and the process is aborted.</span><span class="odfLiEnd"/> </p></li><li><p class="P223" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">2.</span>A database transaction is prepared. If an error occurs, the process is aborted.<span class="odfLiEnd"/> </p></li><li><p class="P223" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">3.</span><span class="text-T60">D</span>eleted accounts are removed from the admin database table as well as from the PostgreSQL database. If an error occurs with either <span class="text-T101">sub-process</span>, the process is aborted and <span class="text-T133">the </span><span class="text-T58">previous changes are reverted.</span><span class="odfLiEnd"/> </p></li><li><p class="P224" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">4.</span><span class="text-T59">Existing admin table entries are updated. </span>New <span class="text-T61">accounts</span> are inserted into the admin table. If an error occurs, the process is aborted and <span class="text-T134">the </span>previous changes are reverted.<span class="odfLiEnd"/> </p></li><li><p class="P225" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">5.</span>Existing admin table entries are granted <span class="text-T109">the specified</span> privileges after all potential privileges are revoked. New accounts are created in the PostgreSQL database and assigned the appropriate privileges. If an error occurs, the process is aborted and the previous changes are reverted.<span class="odfLiEnd"/> </p></li><li><p class="P225" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">6.</span>If all of the <span class="text-T62">aforementioned statements</span> execute correctly, the <span class="text-T155">database </span>transaction is committed.<span class="odfLiEnd"/> </p></li></ol>
<p class="paragraph-P71">Please note that leading and trailing spaces will be removed from user names during the <span class="text-T57">database-</span>recording process.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P72">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.9929in;width:3.5382in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr4" id="Image13"><img style="height:7.602cm;width:8.987cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>
<h1 class="paragraph-P189"><a id="a__BiblioteQ_INI"><span/></a><a id="__RefHeading___Toc2910_2972840720"/>BiblioteQ.INI</h1>

<p class="paragraph-Text_20_body"><a id="__RefHeading___Toc2912_2972840720"/><span class="text-T149">The </span><span class="text-T149">BiblioteQ.INI</span><span class="text-T149"> file contains </span><span class="text-T150">interface settings. The file resides in the user’s home directory within the .biblioteq folder. Editing should be performed with care.</span></p>
<h1 class="paragraph-P190"><a id="a__BiblioteQ_conf"><span/></a><a id="__RefHeading___Toc3090_2972840720"/>BiblioteQ.conf</h1>

<p class="paragraph-Text_20_body"><a id="__RefHeading___Toc3092_2972840720"/><span class="text-T151">The </span><span class="text-T151">BiblioteQ.conf</span><span class="text-T151"> file contains Amazon, SRU, Z39.50, and other information. </span><span class="text-T152">Please edit this file using a text editor.</span></p>
<h1 class="paragraph-P191"><a id="a__Change_Password"><span/></a><a id="__RefHeading___Toc1452_257133660"/>Change Password</h1>

<p class="paragraph-P76">A PostgreSQL account’s password may be changed via the Password Selection dialog. A password must contain at least eight characters. <span class="text-T87">Guest accounts are excluded.</span></p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P76">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:3in;width:4.4791in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr2" id="Image14"><img style="height:7.62cm;width:11.3769cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>
<h1 class="paragraph-P192"><a id="a__Connecting_to_a_PostgreSQL_Database"><span/></a><a id="__RefHeading___Toc363_19725849"/>Connecting to a <span class="text-T110">PostgreSQL </span>Database</h1>

<p class="paragraph-P12">BiblioteQ supports both the PostgreSQL and <span class="text-T11">the </span>SQLite database engines. <span class="text-T10">This section will cover the details involved in connecting to a PostgreSQL database.</span></p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P12">
<!--Next 'div' is emulating the top height of a draw:frame.-->
<div style="height:0.333cm;"> </div>
<!--Next 'div' is a draw:frame. -->
<div style="height:2.4598in;width:3.0835in; padding:0;  float:left; position:relative; left:4.8791cm; " class="graphic-fr1" id="Image5"><img style="height:6.2479cm;width:7.8321cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>

<p class="paragraph-P16">Click the Connect option of the File menu.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P17">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.2811in;width:6.198in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr2" id="Image6"><img style="height:5.794cm;width:15.7429cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>

<p class="paragraph-P17"><span class="text-T102">S</span>elect the appropriate non-local_db Branch Name if one is available. <span class="text-T17">Provide the </span><span class="text-T17">Password</span><span class="text-T17"> and </span><span class="text-T17">Userid</span><span class="text-T17"> information, if applicable, and press the Connect button.</span></p>

<p class="paragraph-P14"><span class="text-T16">Note: </span>The sections Accessing an Existing SQLite Database and Creating an SQLite Database cover the details of accessing and creating SQLite databases, <span class="text-T12">respectively.</span></p>
<p class="paragraph-P14"> </p><h1 class="paragraph-P193"><a id="a__Creating_a_PostgreSQL_Database"><span/></a><a id="__RefHeading___Toc443_940074755"/>Creating a PostgreSQL Database</h1>

<p class="paragraph-Text_20_body">BiblioteQ supports PostgreSQL 8.x, 9.x, and newer. <span class="text-T120">Please note that PostgreSQL 8.x </span><span class="text-T156">and 9.x are not supported by PostgreSQL</span><span class="text-T120">. </span>Please follow the PostgreSQL-provided documentation for installing PostgreSQL. After installing the required PostgreSQL packages, please perform the following operations:</p>
<ol><li><p class="P228" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">1.</span>Create the xbook_db database via createdb xbook_db -E UTF8 or via the PostgreSQL-recommended procedure. Please note that <span class="text-T111">the database name </span>xbook_db is only a suggestion.<span class="odfLiEnd"/> </p></li><li><p class="P228" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">2.</span>Execute createlang plpgsql -d xbook_db or the PostgreSQL-recommended procedure for adding a new programming language to the xbook_db database. <span class="text-T157">If the language already exists, PostgreSQL will produce an error. Please ignore the error.</span><span class="odfLiEnd"/> </p></li><li><p class="P228" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">3.</span>If desired, replace all instances of the default administrator xbook_admin in <span class="text-T88">the</span> postgresql_create_schema.sql file. <span class="text-T171">A password may also be set afterwards.</span><span class="odfLiEnd"/> </p></li><li><p class="P229" style="margin-left:0cm;"><span class="Numbering_20_Symbols" style="display:block;float:left;min-width:0.635cm;">4.</span>Log into your PostgreSQL xbook_db database and load the postgresql_create_schema.sql file via \i postgresql_create_schema.sql.<span class="odfLiEnd"/> </p></li></ol><p class="paragraph-P21"> </p><h1 class="paragraph-P185"><a id="a__Creating_an_SQLite_Database"><span/></a><a id="__RefHeading___Toc322_551497558"/>Creating an SQLite Database</h1>

<p class="paragraph-Text_20_body"><a id="__RefHeading___Toc324_551497558"/>A new BiblioteQ SQLite database file may be created via the New SQLite Database option of the File menu.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-Text_20_body">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.4598in;width:3.0835in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr4" id="Image2"><img style="height:6.2479cm;width:7.8321cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>

<p class="paragraph-P11"><a id="__RefHeading___Toc995_551497558"/><span class="text-T6">After</span> the option is selected, a file-selection dialog is displayed. An existing <span class="text-T198">file </span>or a new file may be specified. A confirmation dialog is displayed if an existing file is selected.</p>

<p class="paragraph-P15">Once the SQLite database file has been initialized, BiblioteQ will open it. If a database is already open,  a confirmation prompt is displayed. If confirmed, the current database is closed and the newly-created <span class="text-T13">database </span>is opened.</p>
<p class="paragraph-Text_20_body"> </p><h1 class="paragraph-P194"><a id="a__Custom_Query"><span/></a><a id="__RefHeading___Toc1520_1056771071"/>Custom Query</h1>

<p class="paragraph-P80">Custom SQL queries may be performed via the Custom Query window.</p>

<p class="paragraph-P107"><span class="text-T137">After a successful query is performed, the main table’s columns will be set according to the query statement. </span><span class="text-T135">Please </span><span class="text-T158">a</span><span class="text-T135">void including columns </span><span class="text-T136">of type Q</span><span class="text-T139">B</span><span class="text-T136">yteArray </span><span class="text-T135">in the custom query as the </span><span class="text-T138">associated data </span><span class="text-T135">will burden the software.</span></p>
<p class="paragraph-P79"> </p><h1 class="paragraph-P195"><a id="a__Database_Content"><span/></a><a id="__RefHeading___Toc2642_1297078973"/>Database Content</h1>

<p class="paragraph-Text_20_body"><a id="__RefHeading___Toc2781_242179693"/>All content, save for configuration values, is stored in the respective database. For instance, image data are stored in a database. Temporary data reside in the application’s memory space.</p>

<p class="paragraph-P127">Image information is recorded as Base-64.</p>
<p class="paragraph-P127"> </p><h1 class="paragraph-P196"><a id="a__Database_Enumerations_Browser"><span/></a><a id="__RefHeading___Toc1455_73510555"/>Database Enumerations Browser</h1>

<p class="paragraph-P78">The Database Enumerations Browser is available to accounts having administrator or librarian privileges and is accessible via the Database Enumerations tool button. <span class="text-T121">The browser contains configurable item values. </span><span class="text-T159">The browser is available for </span><span class="text-T172">PostgreSQL and </span><span class="text-T159">SQLite databases.</span></p>

<p class="paragraph-P75">The process of committing <span class="text-T199">data</span> to <span class="text-T69">a</span> database is as follows:</p>
<ol><li><p class="P230" style="margin-left:0cm;"><span style="display:block;float:left;min-width:0.635cm;">1.</span>For each sub-panel (Book Binding Types, etc.), <span class="text-T111">a </span>database transaction <span class="text-T111">is prepared</span>. If an error occurs, <span class="text-T112">the </span><span class="text-T200">current transaction is canceled and the </span><span class="text-T112">process </span>iterate<span class="text-T112">s</span> to the next sub-panel.<span class="odfLiEnd"/> </p></li><li><p class="P230" style="margin-left:0cm;"><span style="display:block;float:left;min-width:0.635cm;">2.</span><span class="text-T112">Al</span>l items in the <span class="text-T70">respective </span>database table <span class="text-T112">are deleted</span>. For example, for the Book Binding Types sub-panel, all entries from the book_binding_types database table are deleted. If the process fail<span class="text-T70">s</span>, changes <span class="text-T113">are reverted </span>and <span class="text-T113">the process </span>proceed<span class="text-T113">s</span> to the next sub-panel.<span class="odfLiEnd"/> </p></li><li><p class="P231" style="margin-left:0cm;"><span style="display:block;float:left;min-width:0.635cm;">3.</span><span class="text-T113">N</span>ew values <span class="text-T113">are inserted </span>into the respective database table. If the process fails, changes <span class="text-T113">are reverted </span>and <span class="text-T113">the process </span>proceed<span class="text-T113">s</span> to the next sub-panel.<span class="odfLiEnd"/> </p></li><li><p class="P231" style="margin-left:0cm;"><span style="display:block;float:left;min-width:0.635cm;">4.</span><span class="text-T113">T</span>he current database transaction <span class="text-T113">is committed</span>.<span class="odfLiEnd"/> </p></li></ol>
<p class="paragraph-P130"><a id="__RefHeading___Toc413_9400747551"/></p>
<h1 class="paragraph-P197"><a id="a__Disconnecting_from_a_Database"><span/></a><a id="__RefHeading___Toc413_940074755"/>Disconnecting from a Database</h1>

<p class="paragraph-P18">To disconnect from a connected database, click the File menu. Then click the Disconnect option.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P18">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.1902in;width:2.6902in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr2" id="Image7"><img style="height:5.5631cm;width:6.8331cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>
<h1 class="paragraph-P198"><a id="a__Error_Log"><span/></a><a id="__RefHeading___Toc1754_560018603"/>Error Log</h1>

<p class="paragraph-P85">The Error Log may be accessed via the View menu. <span class="text-T75">The window details critical exceptions which were raised during a BiblioteQ session. The status bar of the main window will indicate whether or not the log contains entries.</span></p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P85">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:5.4953in;width:6.9252in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr3" id="Image20"><img style="height:13.9581cm;width:17.59cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>
<h1 class="paragraph-P199"><a id="a__Exporting_a_Table_View_to_a_CSV_File"><span/></a><a id="__RefHeading___Toc460_1725578287"/>Exporting a Table View to a CSV File</h1>

<p class="paragraph-P22">The current table view’s contents may be exported to a CSV file via the Export Table View as CSV option of the File menu.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P22">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.4598in;width:3.0835in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr2" id="Image8"><img style="height:6.2479cm;width:7.8321cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>

<p class="paragraph-P23">If clicked, a file-selection dialog is displayed.</p>

<p class="paragraph-P23">The generated CSV file will contain comma-separated values. Values which contain commas will be encased in double-quotes. <span class="text-T66">For</span> example, <span class="text-T18">A book of abstract algebra,"Pinter, Charles C.",McGraw-Hill,1990-01-01,New York,2,"Algebra, Abstract.",English,0070501386,0.00,Dollar,1,Hardcover,Home,9780070501386,89035355,QA162 .P56 1990,512/.02,1,0,Original,As New,</span><span class="text-T21">.</span></p>

<p class="paragraph-P100">The first line of the generated file contains the exported view’s header strings. <span class="text-T125">The exported columns are governed by the settings in Viewable Columns.</span></p>
<p class="paragraph-P100"> </p><h1 class="paragraph-P200"><a id="a__File_Attachments"><span/></a><a id="__RefHeading___Toc2813_3142272184"/>File Attachments</h1>

<p class="paragraph-P114"><span class="text-T160">Several categories (</span><span class="text-T160">books</span><span class="text-T160">, </span><span class="text-T160">grey literature</span><span class="text-T160">, </span><span class="text-T144">journals</span><span class="text-T144">, </span><span class="text-T160">magazines</span><span class="text-T160">) include file attachments. Attached files are compressed before being inserted into the respective database. </span><span class="text-T141">BiblioteQ </span><span class="text-T161">employs</span><span class="text-T141"> t</span><span class="text-T160">he ZLIB algorithm </span><span class="text-T141">for </span><span class="text-T160">compression.</span></p>
<p class="paragraph-P110"> </p><h1 class="paragraph-P201"><a id="a__Hyperlinks"><span/></a><a id="__RefHeading___Toc2118_278443408"/>Hyperlinks</h1>

<p class="paragraph-P173"><span class="text-T185">BiblioteQ supports embedded </span><span class="text-T185">hyperlinks</span><span class="text-T185">. </span><span class="text-T186">If a hyperlink is </span><span class="text-T185">clicked, a search is initiated using the specified text </span><span class="text-T187">for the given category. Please note that a clicked hyperlink will not be activated if the parent widget is editable. </span><span class="text-T188">An example hyperlink: </span><span class="text-Source_20_Text"><span class="text-T184">&lt;a href='book_search?category?Number </span></span><span class="text-Source_20_Text"><span class="text-T188">T</span></span><span class="text-Source_20_Text"><span class="text-T184">heory'&gt;Number </span></span><span class="text-Source_20_Text"><span class="text-T188">T</span></span><span class="text-Source_20_Text"><span class="text-T184">heory&lt;/a&gt;.</span></span></p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P92">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:1.1in;width:3.9063in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr2" id="Image22"><img style="height:2.794cm;width:9.922000000000001cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>
<h1 class="paragraph-P202"><a id="a__Importing"><span/></a><a id="__RefHeading___Toc2602_4162988163"/>Importing</h1>

<p class="paragraph-P99"><span class="text-T124">BiblioteQ provides an import mechanism for importing book </span><span class="text-T162">and patron</span><span class="text-T124"> data contained in a </span><span class="text-T124">CSV</span><span class="text-T124"> file. Please review the </span><span class="text-T124">Tools</span><span class="text-T124"> menu.</span></p>
<h1 class="paragraph-P203"><a id="a__Limitations"><span/></a><a id="__RefHeading___Toc1814_537498170"/>Limitations</h1>

<p class="paragraph-P102"><span class="text-T127">BiblioteQ does not impose limits on the data content. Please note that both </span><span class="text-T127">PostgreSQL</span><span class="text-T127"> and </span><span class="text-T127">SQLite</span><span class="text-T127"> have rigid </span><span class="text-T126">limits</span><span class="text-T127">. Please read </span><a href="https://www.sqlite.org/limits.html" class="text-Internet_20_link"><span class="text-T127">https://www.sqlite.org/limits.html</span></a><span class="text-T127"> </span><span class="text-T83">for SQLite details.</span></p>

<p class="paragraph-P86">Generally:</p>
<ul><li><p class="P233" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Attached files may be of any size. Please note that submitting large files will burden both local and remote queries. <span class="text-T84">PostgreSQL and/or SQLite may limit field sizes.</span><span class="odfLiEnd"/> </p></li><li><p class="P234" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Infinitely-many items may be stored, although PostgreSQL and/or SQLite may prevent this.<span class="odfLiEnd"/> </p></li><li><p class="P235" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Pagination <span class="text-T85">is implemented with</span> the <span class="text-T201">application</span> of the LIMIT <span class="text-T85">and </span><span class="text-T85">OFFSET</span><span class="text-T85"> clauses.</span><span class="odfLiEnd"/> </p></li><li><p class="P234" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>The number of PostgreSQL accounts is not limited through the software.<span class="odfLiEnd"/> </p></li></ul><p class="paragraph-P86"> </p><h1 class="paragraph-P204"><a id="a__Main_Window_Tool_Buttons"><span/></a><a id="__RefHeading___Toc1050_1842839021"/>Main Window <span class="text-T43">Tool Buttons</span></h1>

<p class="paragraph-P48">This page will describe the various <span class="text-T44">tool buttons</span> <span class="text-T38">which are present on th</span>e main window.</p>

<p class="paragraph-P53">The <span class="text-T42">tool buttons</span> are described from left to right.</p>

<p class="paragraph-P132">View Selected Item(s)</p>

<p class="paragraph-P49">Open the detail <span class="text-T49">window(s)</span> of the selected item(s). A confirmation prompt is displayed if the number of <span class="text-T39">selected </span>items exceeds four. <span class="text-T37">The tool button is disabled if the current account has </span><span class="text-T37">administrator</span><span class="text-T37"> privileges.</span></p>

<p class="paragraph-P133">Add Item</p>

<p class="paragraph-P50">Add an item. The <span class="text-T103">tool button is disabled </span>if the current account does not have Item Creation privileges.</p>

<p class="paragraph-P134">Duplicate Selected Item(s)</p>

<p class="paragraph-P51">Open the detail <span class="text-T50">window(s)</span> of the selected item(s). A confirmation prompt is displayed if the number of selected items exceeds four. The <span class="text-T104">tool button is disabled</span> if the current account does not have Item Creation privileges.</p>

<p class="paragraph-P135">Delete Selected Item(s)</p>

<p class="paragraph-P52">Delete the selected item(s). A confirmation prompt is displayed. The <span class="text-T104">tool button is disabled</span> if the current account does not have Item Deletion privileges.</p>

<p class="paragraph-P136">Modify Selected Item(s)</p>

<p class="paragraph-P54">Modify the selected item(s). A confirmation prompt is displayed if the number of selected items exceeds four. The <span class="text-T105">tool button is disabled </span>if the current account does not have Item Updates privileges.</p>

<p class="paragraph-P137">Print Current View</p>

<p class="paragraph-P55">Print the items in the current view. <span class="text-T51">A Print dialog is displayed.</span></p>

<p class="paragraph-P138">Select Viewable Columns</p>

<p class="paragraph-P56">Select <span class="text-T40">the </span>columns <span class="text-T40">that </span>are to be shown in the main window’s table <span class="text-T119">per each category (books, cds, etc.). Please note that column order is not preserved.</span></p>

<p class="paragraph-P139">View Member’s Reservation History (Patrons Only)</p>

<p class="paragraph-P57">Display the current patron’s reserved item<span class="text-T45">s</span>. The <span class="text-T105">tool button is enabled </span>only for patron <span class="text-T105">accounts</span>.</p>

<p class="paragraph-P140"><span class="text-T52">Request Selected Item(s)</span> / Cancel Selected Request(s)</p>

<p class="paragraph-P58">Available for patrons, these options allow for the requesting of items <span class="text-T46">as well as for</span> the <span class="text-T53">canceling</span> of requested items.</p>

<p class="paragraph-P141">Reserve Selected Item</p>

<p class="paragraph-P59">Reserve the selected item. <span class="text-T106">The tool button is disabled if the current account does not have </span><span class="text-T106">Item </span>Reservations<span class="text-T47"> privileges.</span></p>

<p class="paragraph-P142">Display Members Browser</p>

<p class="paragraph-P60">Display the Members Browser window. <span class="text-T48">Only available for </span><span class="text-T48">administrator</span><span class="text-T48">, </span><span class="text-T48">circulation</span><span class="text-T48">, and </span><span class="text-T48">membership</span><span class="text-T48"> accounts.</span></p>

<p class="paragraph-P143">Files Browser</p>

<p class="paragraph-P111">Display the Files Browser window.</p>

<p class="paragraph-P144">Database Search</p>

<p class="paragraph-P61">Activates a context menu containing various search options.</p>

<p class="paragraph-P145">Custom Database Query</p>

<p class="paragraph-P62">Display <span class="text-T202">a </span>Custom Query window.</p>

<p class="paragraph-P146">Refresh Table</p>

<p class="paragraph-P63">Reload the current view.</p>

<p class="paragraph-P64">Again, the tool buttons are described from left to right.</p>

<p class="paragraph-P147">Connect</p>

<p class="paragraph-P65">Display the Branch Selection dialog.</p>

<p class="paragraph-P148">Disconnect</p>

<p class="paragraph-P66">Disconnect from the current database.</p>

<p class="paragraph-P149">Change Password</p>

<p class="paragraph-P67">Display the Password Selection dialog. Not available for <span class="text-T89">PostgreSQL </span>guest accounts <span class="text-T89">and SQLite databases.</span></p>

<p class="paragraph-P149">Configure Administrator Privileges</p>

<p class="paragraph-P68">Display the Administrator Browser <span class="text-T54">window</span>. Only available for <span class="text-T107">a</span>dministrator accounts. <span class="text-T163">Not available for SQLite databases.</span></p>

<p class="paragraph-P150">Database Enumerations</p>

<p class="paragraph-P69">Display the Database Enumerations Browser window. <span class="text-T48">Only available </span>for <span class="text-T91">a</span>dministrator and <span class="text-T90">l</span>ibrarian accounts.</p>

<p class="paragraph-P151">Exit BiblioteQ</p>

<p class="paragraph-P69">Terminate the application.</p>
<p class="paragraph-P69"> </p><h1 class="paragraph-P205"><a id="a__Members_Browser"><span/></a><a id="__RefHeading___Toc4991_1789080889"/>Members Browser</h1>

<p class="paragraph-Text_20_body">The Members Browser is available <span class="text-T210">via</span> the View menu. For PostgreSQL databases, the browser is accessible if the current role is administrator, circulation, or membership. For SQLite databases, access to the browser is always granted.</p>

<p class="paragraph-Text_20_body">The browser allows administrators to create, delete, and modify patron account details. Reservation processes are also available in the Members Browser. A mechanism for exporting the patron <span class="text-T211">information</span> is also included.</p>

<p class="paragraph-P131">Grant Privileges</p>

<p class="paragraph-Text_20_body">Grant Privileges is available for PostgreSQL databases. If pressed, each listed account is removed from and added to the biblioteq_patron role.</p>

<p class="paragraph-P131"><span class="text-T183">Direct </span>PostgreSQL <span class="text-T183">D</span>ocumentation</p>

<p class="paragraph-Text_20_body"><span class="text-T21">PostgreSQL manages database access permissions using the concept of </span><span class="text-Emphasis"><span class="text-T21">roles</span></span><span class="text-T21">. A role can be thought of as either a database user, or a group of database users, depending on how the role is set up. Roles can own database objects (for example, tables and functions) and can assign privileges on those objects to other roles to control who has access to which objects. Furthermore, it is possible to grant </span><span class="text-Emphasis"><span class="text-T21">membership</span></span><span class="text-T21"> in a role to another role, thus allowing the member role to use privileges assigned to another role.</span></p>

<p class="paragraph-P101">The concept of roles subsumes the concepts of “users” and “groups”. In PostgreSQL versions before 8.1, users and groups were distinct kinds of entities, but now there are only roles. Any role can act as a user, a group, or both.</p>
<p class="paragraph-Text_20_body"> </p><h1 class="paragraph-P206"><a id="a__Member’s_Reservation_History"><span/></a><a id="__RefHeading___Toc1179_960857923"/>Member’s Reservation History</h1>

<p class="paragraph-P70">A patron’s reservation history may be accessed via the Member’s Reservation History window. Reservation histor<span class="text-T55">ies are</span> initially disabled.</p>
<p class="paragraph-P119"> </p><h1 class="paragraph-P207"><a id="a__Open_Library"><span/></a><a id="__RefHeading___Toc3441_676261051"/>Open Library</h1>

<p class="paragraph-P94">BiblioteQ supports <span class="text-T164">the </span><span class="text-T164">Open Library</span> Internet search quer<span class="text-T164">y</span> <span class="text-T100">for </span><span class="text-T100">books</span><span class="text-T100">.</span></p>
<p class="paragraph-P94"> </p><h1 class="paragraph-P208"><a id="a__Operating_Systems"><span/></a><a id="__RefHeading___Toc1583_330706588"/>Operating Systems</h1>

<p class="paragraph-P84">BiblioteQ supports <span class="text-T147">Android</span><span class="text-T147">, </span>FreeBSD, Linux, MacOS, <span class="text-T72">OS/2</span><span class="text-T72">, </span><span class="text-T72">OpenBSD</span><span class="text-T72">, </span>and Windows. Generally, <span class="text-T71">the application</span> <span class="text-T209">is </span>compatible with any operating system where Qt, SQLite, and YAZ are supported. <span class="text-T148">Please note that the YAZ library is totally optional. </span>The software has also been tested on a variety of architectures, including <span class="text-T74">AMD</span><span class="text-T74">, </span>ARM, Alpha, <span class="text-T209">Apple Silicon, </span><span class="text-T73">PowerPC</span><span class="text-T73">, and </span><span class="text-T73">Sun UltraSparc</span><span class="text-T73">.</span></p>
<p class="paragraph-P84"> </p><h1 class="paragraph-P209"><a id="a__PDF"><span/></a><a id="__RefHeading___Toc1774_205534156"/>PDF</h1>

<p class="paragraph-P182">BiblioteQ supports PDF content through the Poppler open source library. Browsing, printing, and searching <span class="text-T78">options are included</span>. <span class="text-T208">Poppler s</span><span class="text-T79">upport is optional. </span><span class="text-T208">Newer versions of Qt also include some PDF functions and BiblioteQ will provide PDF services through Qt if possible.</span></p>
<p class="paragraph-P182"> </p><h1 class="paragraph-P210"><a id="a__PostgreSQL_Accounts"><span/></a><a id="__RefHeading___Toc505_1495128750"/>PostgreSQL Accounts</h1>

<p class="paragraph-P24">BiblioteQ provides three <span class="text-T25">tiers</span> of PostgreSQL <span class="text-T24">database roles</span>: administrator, guest, and patron.</p>

<p class="paragraph-P25">Initially, the postgresql_create_schema.sql script may be used to create the administrator account xbook_admin.</p>

<p class="paragraph-P177">Guest roles are provided a rea<span class="text-T67">d</span>-only interface. Patron roles are gra<span class="text-T68">n</span>ted reservation permissions.</p>

<p class="paragraph-P178">PostgreSQL accounts may be modified via the Administrator Browser. <span class="text-T26">Please note that the Administrator Browser is only available within an administrator role.</span></p>

<p class="paragraph-P248">PostgreSQL credentials are not retained by BiblioteQ. Please consult <a href="https://www.postgresql.org/docs/current/auth-methods.html" class="text-Internet_20_link">https://www.postgresql.org/docs/current/auth-methods.html</a> for information.</p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P247">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:2.8043in;width:6.9252in; padding:0;  float:left; position:relative; left:0cm; " class="graphic-fr1" id="Image9"><img style="height:7.1229cm;width:17.59cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>

<p class="paragraph-P247">Additionally, there are four administrator levels: Administrator, Circulation, Librarian, and Membership. The abilities of each <span class="text-T27">level</span> is described next.</p>

<p class="paragraph-P152">Administrator <span class="text-T207">P</span>ermissions</p>
<ul><li><p class="P236" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Creation<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to create books, etc.<span class="odfLiEnd"/> </p></li><li><p class="P236" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Deletion<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to remove books, etc.<span class="odfLiEnd"/> </p></li><li><p class="P236" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Reservations<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to reserve items.<span class="odfLiEnd"/> </p></li><li><p class="P236" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Returns<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to <span class="text-T28">process</span> returned items.<span class="odfLiEnd"/> </p></li><li><p class="P236" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Updates<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to modify books, etc.<span class="odfLiEnd"/> </p></li><li><p class="P237" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Member Creation<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to create administrators and patrons.<span class="odfLiEnd"/> </p></li><li><p class="P237" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Member Deletion<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to remove administrators and patrons.<span class="odfLiEnd"/> </p></li><li><p class="P237" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Member Updates<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to update information of patrons and permissions of administrators.<span class="odfLiEnd"/> </p></li><li><p class="P237" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Reservation Histories<span class="odfLiEnd"/> </p><p class="P238" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0cm"><!-- --></span>Ability to read reservation histories of patrons.<span class="odfLiEnd"/> </p></li></ul>
<p class="paragraph-P153">Circulation <span class="text-T206">P</span>ermissions</p>
<ul><li><p class="P239" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Reservations<span class="odfLiEnd"/> </p></li><li><p class="P239" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Returns<span class="odfLiEnd"/> </p></li><li><p class="P239" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Reservation Histories<span class="odfLiEnd"/> </p></li></ul>
<p class="paragraph-P153">Librarian <span class="text-T206">P</span>ermissions</p>
<ul><li><p class="P240" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Creation<span class="odfLiEnd"/> </p></li><li><p class="P240" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Deletion<span class="odfLiEnd"/> </p></li><li><p class="P240" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Item Updates<span class="odfLiEnd"/> </p></li></ul>
<p class="paragraph-P153">Membership <span class="text-T206">P</span>ermissions</p>
<ul><li><p class="P241" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Member Creation<span class="odfLiEnd"/> </p></li><li><p class="P241" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Member Deletion<span class="odfLiEnd"/> </p></li><li><p class="P241" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Member Updates<span class="odfLiEnd"/> </p></li></ul><p class="paragraph-P4"> </p><h1 class="paragraph-P211"><a id="a__PostgreSQL_Benefits"><span/></a><a id="__RefHeading___Toc2714_3991642868"/>PostgreSQL Benefits</h1>

<p class="paragraph-P108">PostgreSQL is an open-source relational database management system. <span class="text-T140">Some of the benefits of PostgreSQL include </span><span class="text-T205">the following.</span></p>
<ul><li><p class="P242" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>High <span class="text-T205">S</span>tandards <span class="text-T205">C</span>ompliance<span class="odfLiEnd"/> </p></li><li><p class="P243" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Indices<span class="odfLiEnd"/> </p></li><li><p class="P244" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Networking<span class="odfLiEnd"/> </p></li><li><p class="P245" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Notifications.<span class="odfLiEnd"/> </p></li><li><p class="P245" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Procedural <span class="text-T205">L</span>anguages<span class="odfLiEnd"/> </p></li><li><p class="P246" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Replication<span class="odfLiEnd"/> </p></li><li><p class="P245" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Rich <span class="text-T205">D</span>ata <span class="text-T205">T</span>ypes<span class="odfLiEnd"/> </p></li><li><p class="P246" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Roles<span class="odfLiEnd"/> </p></li><li><p class="P245" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Schema <span class="text-T205">S</span>upport<span class="odfLiEnd"/> </p></li><li><p class="P245" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Transactions<span class="odfLiEnd"/> </p></li><li><p class="P245" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>Triggers<span class="odfLiEnd"/> </p></li><li><p class="P245" style="margin-left:0cm;"><span class="Bullet_20_Symbols" style="display:block;float:left;min-width:0.635cm;">•</span>User-defined <span class="text-T205">T</span>ypes<span class="odfLiEnd"/> </p></li></ul><p class="paragraph-P109"> </p><h1 class="paragraph-P212"><a id="a__PostgreSQL_unaccent__"><span/></a><a id="__RefHeading___Toc2401_2018030115"/>PostgreSQL unaccent()</h1>

<p class="paragraph-P95"><span class="text-T115">BiblioteQ supports PostgreSQL's unaccent() extension. </span>Documentation describing the unaccent() function is <span class="text-T114">located</span> at <a href="https://www.postgresql.org/docs/current/unaccent.html" class="text-Internet_20_link">https://www.postgresql.org/docs/current/unaccent.html</a>.</p>

<p class="paragraph-P96">Greek-language users may wish to supplement their unaccent.rules file<span class="text-T115">s</span> <span class="text-T116">with</span> information contained at <a href="https://gist.github.com/marinoszak/7d5d6a8670faae0f4589c2da988f2ba3" class="text-Internet_20_link">https://gist.github.com/marinoszak/7d5d6a8670faae0f4589c2da988f2ba3</a>. <span class="text-T116">The PostgreSQL database may require restarting after a rules file is altered.</span></p>
<p class="paragraph-P96"> </p><h1 class="paragraph-P213"><a id="a__Preparing_biblioteq_conf"><span/></a><a id="__RefHeading___Toc687_979507714"/><span class="text-T41">Preparing</span> biblioteq.conf</h1>

<p class="paragraph-P26">The biblioteq.conf file contains non-user settings. <span class="text-T29">The location of the file varies with distribution. This page will describe the various properties which may be defined in the biblioteq.conf file.</span></p>

<p class="paragraph-P154">[Amazon <span class="text-T117">Back</span> Cover Images]</p>

<p class="paragraph-P46">Describes required settings for retrieving book <span class="text-T117">back-</span>cover images from amazon.com.</p>

<p class="paragraph-P156">host</p>

<p class="paragraph-P27">Host name of the Amazon image server.</p>

<p class="paragraph-P156">path</p>

<p class="paragraph-P27">Path of the image file. <span class="text-T30">BiblioteQ substitutes the respective ISBN in the percent sign. Please note that </span><span class="text-T30">ASINs</span><span class="text-T30"> may also work.</span></p>

<p class="paragraph-P36">The optional properties proxy_host, proxy_password, proxy_port, proxy_type, and proxy_username are also supported. <span class="text-T33">The proxy_type property supports values of </span><span class="text-T33">HTTP</span><span class="text-T33">, </span><span class="text-T33">None</span><span class="text-T33">, </span><span class="text-T33">Socks5</span><span class="text-T33">, and </span><span class="text-T33">System</span><span class="text-T33">.</span></p>

<p class="paragraph-P155">[Amazon <span class="text-T117">Front </span>Cover Images]</p>

<p class="paragraph-P115">Please read previous section.</p>

<p class="paragraph-P162">[Branch-1]</p>

<p class="paragraph-P29">The first database branch.</p>

<p class="paragraph-P157">connection_options</p>

<p class="paragraph-P33">PostgreSQL-specific connection options. <span class="text-T31">An example is </span><span class="text-T19">connect_timeout=10;sslmode=verify-full</span><span class="text-T31">.</span></p>

<p class="paragraph-P159">database_name</p>

<p class="paragraph-P30">The name of the database as it will appear in the Branch Selection dialog.</p>

<p class="paragraph-P159">database_type</p>

<p class="paragraph-P30">The database’s type. Must be set to postgresql or sqlite.</p>

<p class="paragraph-P160">hostname</p>

<p class="paragraph-P31">The host name <span class="text-T32">of the PostgreSQL database server</span>. Both IP addresses and fully-qualified domain names may be assigned.</p>

<p class="paragraph-P157">port</p>

<p class="paragraph-P32">The port value of the PostgreSQL database server.</p>

<p class="paragraph-P157">ssl_enabled</p>

<p class="paragraph-P32">If false, SSL/TLS communications are disabled.</p>

<p class="paragraph-P158">[Open Library]</p>

<p class="paragraph-P103">Describes required settings for retrieving book information from openlibrary.org</p>

<p class="paragraph-P161">url_isbn</p>

<p class="paragraph-P103">URL of book. BiblioteQ substitutes the respective ISBNs.</p>

<p class="paragraph-P157">[Open Library Cover Images]</p>

<p class="paragraph-P47">Describes required settings for retrieving book cover images from <span class="text-T117">covers.openlibrary.org.</span></p>

<p class="paragraph-P157">back_url</p>

<p class="paragraph-P28"><span class="text-T118">URL</span> of the <span class="text-T118">back-cover </span>image file. <span class="text-T30">BiblioteQ substitutes the respective ISBN in the $value field.</span></p>

<p class="paragraph-P157">front_url</p>

<p class="paragraph-P28"><span class="text-T118">URL</span> of the <span class="text-T118">front-cover</span> image file. <span class="text-T30">BiblioteQ substitutes the respective ISBN in the $value field.</span></p>

<p class="paragraph-P163">[SRU-1]</p>

<p class="paragraph-P39">Describes the first SRU site.</p>

<p class="paragraph-P164">name</p>

<p class="paragraph-P40">Name of the site as it will appear in the application.</p>

<p class="paragraph-P164">url_isbn</p>

<p class="paragraph-P40">Complete URL of the site <span class="text-T34">for retrieving data via ISBNs</span>. The tokens %1 and %2 are replaced by the ISBN-10 and ISBN-13 fields.</p>

<p class="paragraph-P164">url_issn</p>

<p class="paragraph-P41">Complete URL of the site for retrieving data via ISSNs. The token %1 is replaced by the ISSN field.</p>

<p class="paragraph-P37">The optional properties proxy_host, proxy_password, proxy_port, proxy_type, and proxy_username are also supported. <span class="text-T33">The proxy_type property supports values of </span><span class="text-T33">HTTP</span><span class="text-T33">, </span><span class="text-T33">None</span><span class="text-T33">, </span><span class="text-T33">Socks5</span><span class="text-T33">, and </span><span class="text-T33">System</span><span class="text-T33">.</span></p>

<p class="paragraph-P165">[Z39.50-1]</p>

<p class="paragraph-P42">Describes the first Z39.50 site. <span class="text-T35">Please also see </span><a href="http://www.indexdata.com/yaz/doc/zoom.records.html" class="text-Internet_20_link"><span class="text-T35">http://www.indexdata.com/yaz/doc/zoom.records.html</span></a><span class="text-T35">.</span></p>

<p class="paragraph-P166">database_name</p>

<p class="paragraph-P43">The remote database name.</p>

<p class="paragraph-P167">format</p>

<p class="paragraph-P44">Render format. An example: <span class="text-T18">marc8,utf-8</span>.</p>

<p class="paragraph-P166">name</p>

<p class="paragraph-P43">Name of the site as it will appear in the application.</p>

<p class="paragraph-P168">password</p>

<p class="paragraph-P116">Account password. Optional.</p>

<p class="paragraph-P166">port</p>

<p class="paragraph-P43">The remote database’s port number.</p>

<p class="paragraph-P169">record_syntax</p>

<p class="paragraph-P45">Preferred record syntax. Example: <span class="text-T18">MARC21</span>.</p>

<p class="paragraph-P38">The optional properties <span class="text-T36">password</span><span class="text-T36">, </span><span class="text-T36">proxy_host</span>, <span class="text-T36">proxy_port</span>, <span class="text-T36">and </span><span class="text-T36">username</span> are also supported.</p>

<p class="paragraph-P170">timeout</p>

<p class="paragraph-P116">Maximum number of seconds for the query to complete.</p>

<p class="paragraph-P168">username</p>

<p class="paragraph-P116">Account username. Optional.</p>

<p class="paragraph-P171">yaz_</p>

<p class="paragraph-P117">Configure YAZ options. The option (yaz_option minus yaz_) must be supported by the YAZ library. For example, yaz_charset and yaz_databaseName are suitable options.</p>
<p class="paragraph-P117"> </p><h1 class="paragraph-P214"><a id="a__Requesting_an_Item"><span/></a><a id="__RefHeading___Toc1852_1012006322"/>Requesting an Item</h1>

<p class="paragraph-P87">PostgreSQL patrons may request one or mor<span class="text-T86">e </span><span class="text-T86">books</span><span class="text-T86">, </span><span class="text-T86">compact discs</span><span class="text-T86">, </span><span class="text-T86">digital video discs</span><span class="text-T86">, </span><span class="text-T145">grey literature</span><span class="text-T145">, </span><span class="text-T86">journals</span><span class="text-T86">, </span><span class="text-T86">magazines</span><span class="text-T86">, and </span><span class="text-T86">video games</span><span class="text-T86">. After selecting an item, please press the green </span><span class="text-T86">Telephone</span><span class="text-T86"> tool button. To cancel a request, please set the </span><span class="text-T86">Category</span><span class="text-T86"> to </span><span class="text-T86">All Requested</span><span class="text-T86">, select the desired item, and press the red Telephone tool button. A confirmation dialog is displayed and if accepted, the selected request is canceled.</span></p>
<p class="paragraph-P87"> </p><h1 class="paragraph-P215"><a id="a__Reserving_an_Item"><span/></a><a id="__RefHeading___Toc2048_824278855"/>Reserving an Item</h1>

<p class="paragraph-P89">For <span class="text-T93">PostgreSQL</span><span class="text-T93"> databases</span>, items may be reserved by administrator and circulation accounts. Owners of SQLite database<span class="text-T97">s</span> may reserve items. B<span class="text-T86">ooks</span><span class="text-T86">, </span><span class="text-T86">compact discs</span><span class="text-T86">, </span><span class="text-T86">digital video discs</span><span class="text-T86">, </span><span class="text-T143">grey literature</span><span class="text-T143">, </span><span class="text-T86">journals</span><span class="text-T86">, </span><span class="text-T86">magazines</span><span class="text-T86">, and </span><span class="text-T86">video games</span><span class="text-T86"> </span>may be reserved. To reserve an item, select it <span class="text-T94">in the main window </span>and press the Reserve Selected Item tool button. If the item is available for reservation, the Members Browser will be displayed. Select the desired patron in the Members Browser and press the Reserve Selected Item tool button in the Members Browser.  The Copy Browser dialog is displayed. Specify the Due Date <span class="text-T92">and select the desired copy. Finalize the reservation process by clicking the </span><span class="text-T92">Reserve</span><span class="text-T92"> button.</span></p>

<p class="paragraph-P184">Items may also be reserved via the Batch Activities Browser.</p>

<p class="paragraph-P90">Please note that the default Due Date may be modified via the Database Enumerations Browser.</p>
<p class="paragraph-P97"> </p><h1 class="paragraph-P216"><a id="a__Returning_an_Item"><span/></a><a id="__RefHeading___Toc2050_824278855"/>Returning an Item</h1>

<p class="paragraph-P88">For <span class="text-T93">PostgreSQL</span><span class="text-T93"> databases</span>, <span class="text-T95">reserved </span>items may be <span class="text-T95">returned </span>by administrator and circulation accounts. Owners of SQLite database<span class="text-T98">s</span> may <span class="text-T95">return </span>reserve<span class="text-T95">d</span> items. <span class="text-T96">The simplest method of identifying reserved items is by the </span><span class="text-T96">All Reserved</span><span class="text-T96"> category of the </span><span class="text-T96">View</span><span class="text-T96"> menu. An item may be returned via its details window. Open the selected item’s details and click the </span><span class="text-T96">Reservation Status</span><span class="text-T96"> button. The </span><span class="text-T96">Item Reservation Status</span><span class="text-T96"> dialog is displayed. Select the copy which is about to be returned and click the Return button. Confirm the process.</span></p>

<p class="paragraph-P118">Selected items may also be returned via the All Reserved category <span class="text-T204">and the Batch Activities Browser.</span></p>
<p class="paragraph-P118"> </p><h1 class="paragraph-P217"><a id="a__SQL_Injections"><span/></a><a id="__RefHeading___Toc2479_3383179068"/>SQL Injections</h1>

<p class="paragraph-P98">Most BiblioteQ queries are parameterized. Prepared <span class="text-T122">SQL </span>statements are resilient against SQL injections. Please note that some fixed fields (for instance, Locations) are embedded in the statements.</p>
<p class="paragraph-P98"> </p><h1 class="paragraph-P218"><a id="a__SRU___Z39_50"><span/></a><a id="__RefHeading___Toc2216_278443408"/>SRU &amp; Z39.50</h1>

<p class="paragraph-P93">BiblioteQ supports both the SRU and Z39.50 Internet search queries <span class="text-T100">for </span><span class="text-T100">books</span><span class="text-T100">, </span><span class="text-T100">journals</span><span class="text-T100">, and </span><span class="text-T100">magazines</span><span class="text-T100">. Sites may be defined within the </span><span class="text-T100">biblioteq.conf</span><span class="text-T100"> file.</span></p>
<p class="paragraph-P93"> </p><h1 class="paragraph-P217"><a id="a__Special_Data"><span/></a><a id="__RefHeading___Toc2479_33831790681"/>S<span class="text-T166">pecial Data</span></h1>

<p class="paragraph-P121">Dates are recorded in MM/dd/yyyy format.</p>

<p class="paragraph-P120">ISBNs are recorded without hyphens.</p>
<p class="paragraph-P122"> </p><h1 class="paragraph-P219"><a id="a__Terminal_Options"><span/></a><a id="__RefHeading___Toc1119_9608579231"/>T<span class="text-T167">erminal Options</span></h1>

<p class="paragraph-P172">--<span class="text-T191">help</span></p>

<p class="paragraph-P176">Display terminal options.</p>

<p class="paragraph-P123"><span class="text-T212">--open-postgresql-database</span> &lt;name-of-database&gt;</p>

<p class="paragraph-P123">Connect to the specified PostgreSQL database. <span class="text-T169">The connection is established via the guest account.</span></p>

<p class="paragraph-P5"><span class="text-T212">--</span><span class="text-T213">open-sqlite-database</span><span class="text-T168"> &lt;absolute-path-of-database-file&gt;</span></p>

<p class="paragraph-P124">Open the specified SQLite database file.</p>

<p class="paragraph-P124"><span class="text-T212">--</span><span class="text-T214">open-sqlite-database-index</span><span class="text-T180"> &lt;index&gt;</span></p>

<p class="paragraph-P174">Open the SQLite database at the specified index.</p>

<p class="paragraph-P174"><span class="text-T212">--</span><span class="text-T215">prepare-</span><span class="text-T216">csv-</span><span class="text-T215">import-file</span><span class="text-T189"> &lt;absolute-path-of-csv-file&gt;</span></p>

<p class="paragraph-P175">Populates the CSV File widget of the CSV Import Browser with the specified <span class="text-T190">file name</span>. The file should exist.</p>

<p class="paragraph-P124"><span class="text-T212">--</span><span class="text-T217">special-executable</span><span class="text-T175"> &lt;</span><span class="text-T177">absolute-path-of-executable&gt;</span></p>

<p class="paragraph-P125">The argument provided to special-executable will appear in Tools → External Applications. The environment variable BIBLIOTEQ_DATABASE_NAME is available to the new process. Multiple <span class="text-T176">special-executable </span>instances are allowed. <span class="text-T177">Please note that BiblioteQ does not validate the paths of the applications.</span></p>

<p class="paragraph-P125"><span class="text-T212">--</span><span class="text-T218">special-executable-icon</span><span class="text-T178"> &lt;absolute-path-of-icon&gt;</span></p>

<p class="paragraph-P128">Set the action icon of the application specified via --special-executable. <span class="text-T177">Please note that BiblioteQ does not validate the paths of the </span>icons.</p>

<p class="paragraph-P128">Example: BiblioteQ --special-executable /<span class="text-T21">opt/dooble/Dooble –special-executable-icon /opt/dooble/Dooble.png.</span></p>
<p class="paragraph-P126"> </p><h1 class="paragraph-P220"><a id="a__Translations"><span/></a><a id="__RefHeading___Toc1119_960857923"/>Translations</h1>

<p class="paragraph-P6">Translations are incomplete. <span class="text-T3">Translating BiblioteQ </span><span class="text-T128">text </span><span class="text-T3">is simple. Please download and install </span><span class="text-T3">Qt</span><span class="text-T3"> from </span><a href="https://download.qt.io/" class="text-Internet_20_link"><span class="text-T3">https://download.qt.io</span></a><span class="text-T3">, download BiblioteQ’s source, and familiarize yourself with Qt’s </span><span class="text-T3">Linguist</span><span class="text-T3">. Linguist documentation is available at </span><a href="https://doc.qt.io/qt" class="text-Internet_20_link"><span class="text-T3">https://doc.qt.io/qt</span></a><a href="https://doc.qt.io/qt-5/qtlinguist-index.html" class="text-Internet_20_link"><span class="text-T3">/qtlinguist-index.html</span></a><span class="text-T3">.</span></p>

<p class="paragraph-P105">Literal text, for example text housed <span class="text-T129">in</span> a combination-box widget, will be recorded to a database in its translated form. In general, BiblioteQ does not translate database entries.</p>
<p class="paragraph-P104"> </p><h1 class="paragraph-P221"><a id="a__Upgrading_a_PostgreSQL_Database_Schema"><span/></a><a id="__RefHeading___Toc1570_1648101563"/>Upgrading a PostgreSQL Database Schema</h1>

<p class="paragraph-P82">Some software releases require database schema changes. Please read the version-specific section of the postgresql_update_schema.sql file and execute the required SQL statements.</p>
<p class="paragraph-P82"> </p><h1 class="paragraph-P222"><a id="a__Upgrading_an_SQLite_Database_Schema"><span/></a><a id="__RefHeading___Toc1523_1648101563"/>Upgrading an SQLite Database Schema</h1>

<p class="paragraph-P81">It may be necessary to upgrade an existing BiblioteQ SQLite database schema after a software release. <span class="text-T76">An</span> upgrade tool is available <span class="text-T165">via </span>the Tools menu. A confirmation prompt is displayed before the process is initiated. After the upgrade process is completed, a dialog <span class="text-T77">depicting</span> <span class="text-T173">the </span><span class="text-T174">results of the upgrade</span> will be displayed. <span class="text-T123">Please create a </span><span class="text-T203">copy</span><span class="text-T123"> of the SQLite database </span><span class="text-T203">file </span><span class="text-T123">before upgrading it.</span></p>

<!--Next 'div' was a 'text:p'.-->
<div class="paragraph-P81">
<!--Next 'div' is emulating the top height of a draw:frame.-->

<!--Next 'div' is a draw:frame. -->
<div style="height:3.5728in;width:4.3752in; padding:0;  float:left; position:relative; left:3.239cm; " class="graphic-fr1" id="Image18"><img style="height:9.0749cm;width:11.113cm;" alt="" src=""/></div><div style="clear:both; line-height:0; width:0; height:0; margin:0; padding:0;"> </div></div>
Index
<p class="paragraph-P181">Index</p>

<p class="paragraph-P183">Accessing an Existing SQLite Database        11</p>

<p class="paragraph-P183">Add Item        6, 24</p>

<p class="paragraph-P183">admin        7</p>

<p class="paragraph-P183">administrator        6 f., 16, 24 ff., 32, 40 f.</p>

<p class="paragraph-P183">Administrator        32</p>

<p class="paragraph-P183">Administrator Browser        7, 25, 32</p>

<p class="paragraph-P183">Administrator Guide        3</p>

<p class="paragraph-P183">All Requested        39</p>

<p class="paragraph-P183">All Reserved        41</p>

<p class="paragraph-P183">Alpha        30</p>

<p class="paragraph-P183">AMD        30</p>

<p class="paragraph-P183">Android        30</p>

<p class="paragraph-P183">ARM        30</p>

<p class="paragraph-P183">ASINs        36</p>

<p class="paragraph-P183">back_url        37</p>

<p class="paragraph-P183">biblioteq_patron        27</p>

<p class="paragraph-P183">biblioteq.conf        36, 43</p>

<p class="paragraph-P183">BiblioteQ.conf        9</p>

<p class="paragraph-P183">BiblioteQ.INI        8</p>

<p class="paragraph-P183">Book Binding Types        16</p>

<p class="paragraph-P183">books        6, 20, 29, 39, 43</p>

<p class="paragraph-P183">Books        40</p>

<p class="paragraph-P183">Branch Name        5, 11</p>

<p class="paragraph-P183">Branch Selection        4, 25, 36</p>

<p class="paragraph-P183">Category        39</p>

<p class="paragraph-P183">Change Password        25</p>

<p class="paragraph-P183">circulation        25, 27, 40 f.</p>

<p class="paragraph-P183">Circulation        32</p>

<p class="paragraph-P183">Clear        4</p>

<p class="paragraph-P183">compact discs        6, 39 f.</p>

<p class="paragraph-P183">Configure Administrator Privileges        7, 25</p>

<p class="paragraph-P183">Connect        4, 11, 25</p>

<p class="paragraph-P183">connection_options        36</p>

<p class="paragraph-P183">Copy Browser        40</p>

<p class="paragraph-P183">createdb        12</p>

<p class="paragraph-P183">createlang        12</p>

<p class="paragraph-P183">Creating an SQLite Database        11</p>

<p class="paragraph-P183">CSV        19, 22</p>

<p class="paragraph-P183">Custom Database Query        25</p>

<p class="paragraph-P183">Custom Query        14</p>

<p class="paragraph-P183">Database Enumerations        16, 25</p>

<p class="paragraph-P183">Database Enumerations Browser        16, 26, 40</p>

<p class="paragraph-P183">Database Search        25</p>

<p class="paragraph-P183">database_name        36 f.</p>

<p class="paragraph-P183">database_type        36</p>

<p class="paragraph-P183">Delete Selected Item(s)        24</p>

<p class="paragraph-P183">digital video discs        6, 39 f.</p>

<p class="paragraph-P183">Disconnect        17, 25</p>

<p class="paragraph-P183">Display Members Browser        25</p>

<p class="paragraph-P183">Due Date        40</p>

<p class="paragraph-P183">Duplicate Selected Item(s)        24</p>

<p class="paragraph-P183">Error Log        18</p>

<p class="paragraph-P183">Exit BiblioteQ        26</p>

<p class="paragraph-P183">Export Table View as CSV        19</p>

<p class="paragraph-P183">File        4, 11, 13, 17, 19</p>

<p class="paragraph-P183">Files Browser        25</p>

<p class="paragraph-P183">format        38</p>

<p class="paragraph-P183">FreeBSD        30</p>

<p class="paragraph-P183">front_url        37</p>

<p class="paragraph-P183">Grant Privileges        27</p>

<p class="paragraph-P183">grey literature        6, 20, 39 f.</p>

<p class="paragraph-P183">guest        25, 32</p>

<p class="paragraph-P183">host        36</p>

<p class="paragraph-P183">hostname        36</p>

<p class="paragraph-P183">HTTP        36 f.</p>

<p class="paragraph-P183">hyperlinks        21</p>

<p class="paragraph-P183">Item Creation        24, 32 f.</p>

<p class="paragraph-P183">Item Deletion        24, 32 f.</p>

<p class="paragraph-P183">Item Reservation Status        41</p>

<p class="paragraph-P183">Item Reservations        25, 32 f.</p>

<p class="paragraph-P183">Item Returns        33</p>

<p class="paragraph-P183">Item Updates        24, 33</p>

<p class="paragraph-P183">journals        6, 20, 39 f., 43</p>

<p class="paragraph-P183">librarian        6, 16, 26</p>

<p class="paragraph-P183">Librarian        32</p>

<p class="paragraph-P183">LIMIT        23</p>

<p class="paragraph-P183">Linguist        46</p>

<p class="paragraph-P183">Linux        30</p>

<p class="paragraph-P183">local_db        5, 11</p>

<p class="paragraph-P183">MacOS        30</p>

<p class="paragraph-P183">magazines        6, 20, 39 f., 43</p>

<p class="paragraph-P183">Member Creation        33</p>

<p class="paragraph-P183">Member Deletion        33</p>

<p class="paragraph-P183">Member Updates        33</p>

<p class="paragraph-P183">Member’s Reservation History        28</p>

<p class="paragraph-P183">Members Browser        40</p>

<p class="paragraph-P183">membership        25, 27</p>

<p class="paragraph-P183">Membership        32</p>

<p class="paragraph-P183">Modify Selected Item(s)        24</p>

<p class="paragraph-P183">name        37 f.</p>

<p class="paragraph-P183">New SQLite Database        13</p>

<p class="paragraph-P183">None        36 f.</p>

<p class="paragraph-P183">OFFSET        23</p>

<p class="paragraph-P183">Open Library        29</p>

<p class="paragraph-P183">OpenBSD        30</p>

<p class="paragraph-P183">OS/2        30</p>

<p class="paragraph-P183">Pagination        23</p>

<p class="paragraph-P183">password        10, 38</p>

<p class="paragraph-P183">Password        11</p>

<p class="paragraph-P183">Password Selection        10, 25</p>

<p class="paragraph-P183">path        36</p>

<p class="paragraph-P183">patron        24, 32</p>

<p class="paragraph-P183">patrons        39</p>

<p class="paragraph-P183">PDF        31</p>

<p class="paragraph-P183">photograph collections        6</p>

<p class="paragraph-P183">plpgsql        12</p>

<p class="paragraph-P183">Poppler        31</p>

<p class="paragraph-P183">port        36, 38</p>

<p class="paragraph-P183">postgresql        36</p>

<p class="paragraph-P183">PostgreSQL        3, 6 f., 11 f., 23, 27, 32, 39 ff.</p>

<p class="paragraph-P183">postgresql_create_schema.sql        12, 32</p>

<p class="paragraph-P183">postgresql_update_schema.sql        47</p>

<p class="paragraph-P183">PowerPC        30</p>

<p class="paragraph-P183">Print Current View        24</p>

<p class="paragraph-P183">proxy_host        36 ff.</p>

<p class="paragraph-P183">proxy_password        36 f.</p>

<p class="paragraph-P183">proxy_port        36 ff.</p>

<p class="paragraph-P183">proxy_type        36 f.</p>

<p class="paragraph-P183">proxy_username        36 f.</p>

<p class="paragraph-P183">Qt        30, 46</p>

<p class="paragraph-P183">Qt LTS        3</p>

<p class="paragraph-P183">reate        6</p>

<p class="paragraph-P183">Recent SQLite Files        4</p>

<p class="paragraph-P183">record_syntax        38</p>

<p class="paragraph-P183">Refresh Table        25</p>

<p class="paragraph-P183">Request Selected Item(s) / Cancel Selected Request(s)        24</p>

<p class="paragraph-P183">Reservation Histories        33</p>

<p class="paragraph-P183">Reservation Status        41</p>

<p class="paragraph-P183">Reserve        40</p>

<p class="paragraph-P183">Reserve Selected Item        25, 40</p>

<p class="paragraph-P183">Save Changes        7</p>

<p class="paragraph-P183">Select SQLite Database        5</p>

<p class="paragraph-P183">Select Viewable Columns        24</p>

<p class="paragraph-P183">Socks5        36 f.</p>

<p class="paragraph-P183">sqlite        36</p>

<p class="paragraph-P183">SQLite        3 f., 6, 11, 13, 23, 27, 30, 48</p>

<p class="paragraph-P183">SRU        43</p>

<p class="paragraph-P183">ssl_enabled        37</p>

<p class="paragraph-P183">Sun UltraSparc        30</p>

<p class="paragraph-P183">System        36 f.</p>

<p class="paragraph-P183">Telephone        39</p>

<p class="paragraph-P183">timeout        38</p>

<p class="paragraph-P183">Tools        22, 48</p>

<p class="paragraph-P183">Translations        46</p>

<p class="paragraph-P183">unaccent()        35</p>

<p class="paragraph-P183">upgrade        48</p>

<p class="paragraph-P183">url_isbn        37</p>

<p class="paragraph-P183">url_issn        37</p>

<p class="paragraph-P183">Userid        11</p>

<p class="paragraph-P183">username        38</p>

<p class="paragraph-P183">video games        6, 39 f.</p>

<p class="paragraph-P183">View        18, 27, 41</p>

<p class="paragraph-P183">View Member’s Reservation History (Patrons Only)        24</p>

<p class="paragraph-P183">View Selected Item(s)        24</p>

<p class="paragraph-P183">Windows        30</p>

<p class="paragraph-P183">xbook_admin        12, 32</p>

<p class="paragraph-P183">xbook_db        12</p>

<p class="paragraph-P183">YAZ        3, 30</p>

<p class="paragraph-P183">yaz_        38</p>

<p class="paragraph-P183">Z39.50        43</p>

<p class="paragraph-P183"> Administrator Privileges        7</p>

<p class="paragraph-P183">[Amazon Back Cover Images]        36</p>

<p class="paragraph-P183">[Amazon Front Cover Images]        36</p>

<p class="paragraph-P183">[Branch-1]        36</p>

<p class="paragraph-P183">[Open Library Cover Images]        37</p>

<p class="paragraph-P183">[Open Library]        37</p>

<p class="paragraph-P183">[SRU-1]        37</p>

<p class="paragraph-P183">[Z39.50-1]        37</p>
<p class="paragraph-P3"> </p></body>

</html>
